
CREATE TABLE daycare.MedicationReminders
  (
   MedicationReminderId INT NOT NULL
                            IDENTITY(1,1)
                            PRIMARY KEY
 , ReminderId INT NOT NULL
 , ChildMedicationId INT NOT NULL
  )
ALTER TABLE daycare.MedicationReminders ADD CONSTRAINT FK_MedicationReminders_Reminder FOREIGN KEY(ReminderId) REFERENCES daycare.Reminders(ReminderId)
ALTER TABLE daycare.MedicationReminders ADD CONSTRAINT FK_MedicationReminders_ChildMedication FOREIGN KEY(ChildMedicationId) REFERENCES daycare.ChildMedications(ChildMedicationId)
GO